- Melakukan koneksi ke internet dan bekerja dengan internet
- Pertama kita buat script PHP seperti berikut :
· index.php ( Halaman Pertama PHP )<?phpecho "<html><head><body background=\"MyUbuntu.jpg\"><font color=\"white\"><h2 align=center><u><i>DAFTAR PEGAWAI BARU</u></i></h2></font><table width=\"430\" height=\"219\" border=\"10\" align=\"center\" cellpadding=\"7\" cellspacing=\"2\" bgcolor=\"#333333\" style=\"margin-top:50px;\"><form action=\"index1.php\" class=\"js-signin signin\" method=\"post\"><tr bgcolor=\"#CCCCCC\"><td colspan=\"2\" align=\"center\" bgcolor=\"#FF0000\"><b>Daftar Disini</b></td></tr><tr bgcolor=\"#FFFFFF\"><td width=\"120\" bordercolor=\"#FFFFFF\" bgcolor=\"yellow\">Nama</td><td width=\"100\" bordercolor=\"#FFFFFF\" bgcolor=\"#66FFFF\"><input name=\"Nama\" type=\"text\" size=\"40\" required=\"required\" placeholder=\"Masukkan Nama Anda\"/></td></tr><tr bgcolor=\"#FFFFFF\"><td bordercolor=\"#FFFFFF\" bgcolor=\"yellow\">Nomor Pegawai</td><td bordercolor=\"#FFFFFF\" bgcolor=\"#66FFFF\"><input name=\"NoPegawai\" type=\"number\" size=\"40\" required=\"required\" placeholder=\"Masukkan Nomor Anda\"/></td><tr bgcolor=\"#FFFFFF\"><td bordercolor=\"#FFFFFF\" bgcolor=\"yellow\">User ID</td><td bordercolor=\"#FFFFFF\" bgcolor=\"#66FFFF\"><input name=\"UserID\" type=\"email\" size=\"40\" required=\"required\" placeholder=\"Masukkan User Anda\"/></td></tr><tr bgcolor=\"#FFFFFF\"><td width=\"120\" bordercolor=\"#FFFFFF\" bgcolor=\"yellow\">Password</td><td width=\"100\" bordercolor=\"#FFFFFF\" bgcolor=\"#66FFFF\"><input name=\"Password\" type=\"password\" size=\"40\" required=\"required\" placeholder=\"Masukkan Password Anda\"/></td></tr></tr><tr bgcolor=\"#FFFFFF\"><td colspan=\"2\" align=\"center\" bgcolor=\"#CCFF99\"><a href=\"indexneww.php\"><input type=\"button\" value='Cari Pegawai' align=\"center\"></a><input type=\"submit\" name=\"Submit\" value=\"Daftar\" /><a href=\"table.php\"><input type=\"button\" value='Lihat Pegawai' align=\"center\"></a><br><hr><a href=\"backup.php\"><input type=\"button\" value='Backup Data' align=\"center\"></a><a href=\"recovery_data.php\"><input type=\"button\" value='Restore Data' align=\"center\"></a></td></tr><tr bgcolor=\"lightgray\"></form></table><div align=\"center\"></div></body></head></html>";?>Dan hasilnya adalah seperti berikut :
2. Lalu kita buat script PHP seperti berikut :
· index1.php ( File Koneksi Pendaftaran )<?php$kom = "localhost";$user = "root";$pass = "12345";$data = "index.php";$sambung=mysql_connect($kom,$user,$pass);$pilih=mysql_select_db($data);include('index.php');$A = $_POST [Nama];$B = $_POST [NoPegawai];$C = $_POST [UserID];$D = $_POST [Password];$Q = "INSERT INTO `haviz syah v`.`laptop` (`Nama` ,`NoPegawai` ,`UserID` ,`Password`)VALUES ('$A', '$B', '$C', '$D')";$H = mysql_query ($Q);echo "<font color=\"green\"><h3 align=center><blink><b>TERIMA KASIH ANDA TELAH BERHASIL MENJADI PEGAWAI</h2></b></blink></font></p>";?>
3. Kemudian kita buat script PHP seperti berikut :· table.php ( Daftar Table Pegawai )<?php$user = "root";$password = "12345";$komputer = "localhost";$data = "haviz syah v";$sambung = mysql_connect($komputer,$user,$password);$pilah = mysql_select_db($data);$cari = "SELECT * FROM `laptop` WHERE `Nama` like '%'" ;$a=mysql_query($cari);echo "<html><body background=\"MyUbuntu.jpg\"><h2 align=center><font color=\"white\">Daftar Pegawai</font></h2><table width=\"720\" height=\"219\" border=\"10\" align=\"center\" cellpadding=\"10\" cellspacing=\"2\" bgcolor=\"#333333\" style=\"margin-top:50px;\"><tr bgcolor=\"red\"><th>Nama</th><th>Nomor Pegawai</th><th>User ID</th><th>Password</th><th>Opsi</th></tr>";$while= mysql_query ("SELECT*FROM laptop ORDER BY Nama");$no=1;while($data = mysql_fetch_array($while)){echo "<tr><td bgcolor=\"yellow\" align=\"center\">$data[0]</td><td bgcolor=\"lightgreen\" align=\"center\">$data[1]</td><td bgcolor=\"yellow\" align=\"center\">$data[2]</td><td bgcolor=\"lightgreen\" align=\"center\">$data[3]</td><th bgcolor=\"yellow\" align=\"center\"><a href=edit.php?Nama=$data[Nama] ><input type=submit value='Edit' align=center></a><a href=\"delete.php?Nama=$data[Nama]\" onClick=\"return confirm('Anda yakin ingin menghapus $data[Nama]')\"><input type=submit value='Delete' align=center></a></th></tr>";}echo "</table><h2 align=center><a href=\"index.php\">Klik Disini Untuk Kembali</h2></a></body></html>";?>Dan hasilnya adalah seperti berikut :
4. Setelah itu kita buat script PHP seperti berikut :
· edit.php ( Untuk Mengedit Pegawai Yang Telah Terdaftar )<html><head><title>Edit Data</title></head><body background="MyUbuntu.jpg"><?php$user="root";$pass="12345";$kom="localhost";$data="haviz syah v";$sambung= mysql_connect ( $kom,$user,$pass );$pilih= mysql_select_db( $data );$edit = mysql_query("SELECT * FROM `laptop` WHERE Nama='$_GET[Nama]'");$data = mysql_fetch_array($edit);echo "<form method=POST action=upload.php><input type=hidden name=Nama value='$data[Nama]'><table align=center border=0 cellpadding=20><tr><th colspan=2><font size='6'>Edit Data Pegawai</font></h1></th></tr><tr><th align=right>Nama </th><td> : <input type='text' maxlength='10' name='Nama' value='$data[Nama]' disabled></td></tr><tr><th align=right>Nomor Pegawai </th><td> : <input type='text' maxlength='15' name='NoPegawai' value='$data[NoPegawai]' required=\"required\"></td></tr><tr><th align=right>User ID </th><td> : <input type='text' maxlength='30' name='UserID' value='$data[UserID]' required=\"required\"></td></tr><tr><th align=right>Password </th><td> : <input type='text' maxlength='30' name='Password' value='$data[Password]' required=\"required\"></td></tr></table><h2 align=center><input type=submit value=Upload><input type=button value=Batal onclick=self.history.back()></form></h2>";?></body></html>Dan hasilnya adalah seperti berikut :
5. Lalu kita buat script PHP seperti berikut :
· upload.php ( Untuk Mengupload Hasil Editan Yang Telah Diedit )<html><body background="MyUbuntu.jpg"><?php$user="root";$pass="12345";$kom="localhost";$data="haviz syah v";$sambung= mysql_connect ( $kom,$user,$pass );$pilih= mysql_select_db( $data );$update= mysql_query ("UPDATE laptop SET Nama = '$_POST[Nama]',NoPegawai = '$_POST[NoPegawai]',UserID = '$_POST[UserID]',Password = '$_POST[Password]' WHERE Nama = '$_POST[Nama]'");if($update) {echo "<br>";echo "<br>";echo "<br>";echo "<br>";echo "<br>";echo "<br>";echo "<br>";echo "<br>";echo "<br>";echo "<br>";echo "<br>";echo "<h2 align=\"center\"><blink>Data Berhasil Tersimpan</blink></h2></p>";}else {echo "<h2 align=\"center\"><blink>Data Tidak Bisa Tersimpan</blink></h2></p>";}?><br><h2 align=center><a href="index.php"><input type="button" value='Kembali' align=center></a><a href ="table.php"><input type=submit name=Tabel value=Tabel></a></h2></td></tr></body></html>6. Kemudian kita buat script PHP seperti berikut :· delete.php ( Untuk Mendelete Pegawai Yang Telah Terdaftar )<?php$user="root";$pass="12345";$kom="localhost";$data="haviz syah v";$sambung= mysql_connect ( $kom,$user,$pass );$pilih= mysql_select_db( $data );$hapus=mysql_query("DELETE FROM laptop WHERE Nama='$_GET[Nama]'");header('location:table.php');?>7. Setelah itu kita buat script PHP seperti berikut :· indexneww.php ( Halaman Untuk Pencarian Pegawai )<?phpecho "<html><head><body background=\"MyUbuntu.jpg\"><font color=\"white\"><h2 align=center><u><i>Pencarian Pegawai</u></i></h2></font><table width=\"448\" height=\"219\" border=\"10\" align=\"center\" cellpadding=\"7\" cellspacing=\"2\" bgcolor=\"#333333\" style=\"margin-top:50px;\"><form action=\"hasil-pencarian.php\" method=\"post\"><tr bgcolor=\"#CCCCCC\"><td colspan=\"2\" align=\"center\" bgcolor=\"#FF0000\"><b>Form Pencarian Pegawai</b></td></tr><tr bgcolor=\"#FFFFFF\"><td width=\"60\" bordercolor=\"#FFFFFF\" bgcolor=\"yellow\">Nama</td><td width=\"202\" bordercolor=\"#FFFFFF\" bgcolor=\"#66FFFF\"><input name=\"Nama\" type=\"text\" size=\"45\" required=\"required\" placeholder=\"Masukkan Nama Pegawai\"/></td></tr></tr><tr bgcolor=\"#FFFFFF\"><td colspan=\"2\" align=\"center\" bgcolor=\"#CCFF99\"><input type=\"submit\" name=\"Submit\" value=\"Cari\" /><a href=\"index.php\"><input type=\"button\" value='Kembali' align=\"center\"></td></tr></form></table><div align=\"center\"></div></body></head></html>";?>Dan hasilnya adalah seperti berikut :8. Lalu kita buat script PHP seperti berikut :
· hasil-pencarian.php ( Untuk Menampilkan Hasil Pencarian Pegawai Yang Telah Dicari )<?php$user="root";$pass="12345";$kom="localhost";$data="haviz syah v";$sambung= mysql_connect ( $kom,$user,$pass );$pilih= mysql_select_db( $data );$nama= $_POST['Nama'];$q = "SELECT * from laptop where Nama like '%$Nama%' ";$result = mysql_query($q);echo "<body background=\"MyUbuntu.jpg\">";echo "<center>";echo "<h2><font color=\"white\">Hasil Pencarian</font></h2>";echo "<table width=\"600\" height=\"110\" border=\"10\" align=\"center\" cellpadding=\"7\" cellspacing=\"2\" bgcolor=\"#333333\" style=\"margin-top:50px;\">";echo "<tr bgcolor=\"red\"><th>Nama</th><th>Nomor Pegawai</th><th>User ID</th><th>Password</th><th>Opsi</th></tr>";$i=0;while ($data = mysql_fetch_array($result)) {$i++ ;echo "<tr><td bgcolor='yellow' align=\"center\">$data[0]</td><td bgcolor='lightgreen' align=\"center\">$data[1]</td><td bgcolor='yellow' align=\"center\">$data[2]</td><td bgcolor='lightgreen' align=\"center\">$data[3]</td><th bgcolor=\"yellow\"><a href=edit.php?Nama=$data[Nama] class=a><input type=submit value='Edit' align=center></a><a href=\"delete.php?Nama=$data[Nama]\" class=a onClick=\"return confirm('Anda Yakin Menghapus Akun >>$data[Nama]<< Ini.')\"><input type=submit value='Hapus' align=center></a></th></tr>";}echo "</table>";echo "<br>";echo "<a href=\"index.php\"><input type=\"button\" value='Kembali' align=center></a>";echo "<a href =\"table.php\"><input type=submit name=Coba Lagi value='Daftar Pegawai'></a></td></tr></h2>";?>Dan hasilnya adalah seperti berikut :
Kamis, 18 September 2014
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar